From 030b5bffb2df12d2dd6d0a9cc865d01ceaa2ccda Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 5 Aug 2026 16:46:46 +0000 Subject: [PATCH] Add example query to LOCATIONS_PAPER doc --- doc/src/tables/locations_paper.m4 | 34 +++++++++++++++++++++++++++---- 1 file changed, 30 insertions(+), 4 deletions(-) diff --git a/doc/src/tables/locations_paper.m4 b/doc/src/tables/locations_paper.m4 index 0472f6a..326a24f 100644 --- a/doc/src/tables/locations_paper.m4 +++ b/doc/src/tables/locations_paper.m4 @@ -30,10 +30,6 @@ LOCATIONS_PAPER (spatial LOCATIONS in map numbers) |LOCATIONS_PAPER_summary| -.. sidebar:: - - |OBS helpful| - The system will generate a warning if the community of the follow related to the location information, or that of the |WATCHES| row that exists to support the location record, is not the community associated @@ -41,6 +37,36 @@ with the location record. This means, if the LOCATIONS_PAPER.\ |LOCATIONS_PAPER.CommID| is not the |WATCHES|.\ |WATCHES.CommID| of the related |WATCHES| row. +The |OBS| view is useful when querying LOCATIONS_PAPER. + +.. code-block:: sql + :caption: + Using OBS to provide a more complete picture of locations + tracked on paper maps + + SELECT obs.wid + , obs.eid + , obs.date + , obs.animid + , obs.commid AS watchescommid + , obs.start AS time + , locations_paper.mapseq + , locations_paper.meterstonextmapseq + , locations_paper.commid AS papercommid + , locations_paper.follownum + , locations_paper.origin + , locations_paper.entered + , obs.notes AS watch_notes + , obs.event_notes + , locations_paper.notes + FROM obs + JOIN locations_paper + ON (locations_paper.eid = obs.eid) + WHERE obs.behavior = 'sdb_paper' + ORDER BY obs.animid, obs.date, obs.start + , obs.eid; + + .. contents:: :depth: 2 -- 2.34.1